Managing PostgreSQL database via pgAdmin
The pgAdmin is the most popular open-source administration and development platform for PostgreSQL. pgAdmin is a powerful tool to manage PostgreSQL.
1. Locate your target deployment
Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.
2．Get connection string information
Click the "Manage" button on the Home page or the My Applications page to go to the Overview page.
Go to the Connection Information section to get the PostgreSQL shell connection string.
3．Connect to databases using pgAdmin
Download PgAdmin tool at https://www.pgadmin.org/download/
Start the PgAdmin tool and set up a new database connection as the screenshot.
Fill in the requested information to connect the database.
General name – The name that will be shown in pgAdmin (Does not affect connection)
Server group – Select Servers
Connect now – Enable it
Hostname/address – The IP address or hostname for the PostgreSQL server
Port – Port information is defined in the control panel
Maintenance database- The database name that you want to connect
Username – The database user
Password– Enter your PostgreSQL database's password and save it
4. Edit and manage your database
Click on the created connection to connect to your database, and now you are ready to manage your database as you like.
